Tabela WMPORDINANCE

Definicja tabeli WMPORDINANCE

Name

WMPORDINANCE

Code

WMPORDINANCE

Comment

Rozporzadzenie WMP


Lista kolumn tabeli WMPORDINANCE

Name

Code

WMPORDINANCEID

WMPORDINANCEID

ACTIVE

ACTIVE

COMMENTARY

COMMENTARY

WMPCONTRACTKIND

WMPCONTRACTKIND

DATEFROM

DATEFROM

DATETO

DATETO

ORDERNUMBER

ORDERNUMBER

ORDINANCENUMBER

ORDINANCENUMBER

ORDINANCEDATE

ORDINANCEDATE


Kolumna WMPORDINANCEID tabeli WMPORDINANCE

Definicja kolumny WMPORDINANCEID tabeli WMPORDINANCE

Name

WMPORDINANCEID

Code

WMPORDINANCEID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

identyfikator


Kolumna ACTIVE tabeli WMPORDINANCE

Definicja kolumny ACTIVE tabeli WMPORDINANCE

Name

ACTIVE

Code

ACTIVE

Data Type

NUMBER(3)

Mandatory

No

Comment

informacja czy umowa jest aktywna


Kolumna COMMENTARY tabeli WMPORDINANCE

Definicja kolumny COMMENTARY tabeli WMPORDINANCE

Name

COMMENTARY

Code

COMMENTARY

Data Type

VARCHAR2(255)

Mandatory

No

Comment

komentarz


Kolumna WMPCONTRACTKIND tabeli WMPORDINANCE

Definicja kolumny WMPCONTRACTKIND tabeli WMPORDINANCE

Name

WMPCONTRACTKIND

Code

WMPCONTRACTKIND

Data Type

VARCHAR2(255)

Mandatory

No

Comment

rodzaj rozporzadzenia WMP (WMP/OMS)


Kolumna DATEFROM tabeli WMPORDINANCE

Definicja kolumny DATEFROM tabeli WMPORDINANCE

Name

DATEFROM

Code

DATEFROM

Data Type

DATE

Mandatory

No

Comment

data obowiazywania od


Kolumna DATETO tabeli WMPORDINANCE

Definicja kolumny DATETO tabeli WMPORDINANCE

Name

DATETO

Code

DATETO

Data Type

DATE

Mandatory

No

Comment

data obowiazywania do


Kolumna ORDERNUMBER tabeli WMPORDINANCE

Definicja kolumny ORDERNUMBER tabeli WMPORDINANCE

Name

ORDERNUMBER

Code

ORDERNUMBER

Data Type

VARCHAR2(255)

Mandatory

No

Comment

numer porzadkowy


Kolumna ORDINANCENUMBER tabeli WMPORDINANCE

Definicja kolumny ORDINANCENUMBER tabeli WMPORDINANCE

Name

ORDINANCENUMBER

Code

ORDINANCENUMBER

Data Type

VARCHAR2(255)

Mandatory

No

Comment

numer rozporzadzenia


Kolumna ORDINANCEDATE tabeli WMPORDINANCE

Definicja kolumny ORDINANCEDATE tabeli WMPORDINANCE

Name

ORDINANCEDATE

Code

ORDINANCEDATE

Data Type

DATE

Mandatory

No

Comment

data rozporzadzenia


Lista kluczy tabeli WMPORDINANCE

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli WMPORDINANCE

Definicja klucza Identifier_1 tabeli WMPORDINANCE

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment